 CREATE EXTERNAL TABLE jms_dwd.dwd_yl_oms_order_delivery_record_base_dt(
   `id` bigint COMMENT '主键ID',                      
   `waybill_id` string COMMENT '运单号',               
   `delivery_staff_name` string COMMENT '派件业务员名称',  
   `delivery_staff_code` string COMMENT '派件业务员编码',  
   `delivery_option` bigint COMMENT '派送选项 1、派送上门  2、放驿站  3、未接通',  
   `upload_time` timestamp COMMENT '上传时间',          
   `push_source` string COMMENT '推送来源',             
   `input_time` timestamp COMMENT '录入时间',           
   `update_time` timestamp COMMENT '修改时间',          
   `is_delete` bigint COMMENT '是否删除 1：未删除 2：已删除')   
 COMMENT '订单派送记录表'                                  
 PARTITIONED BY (
   `dt` string COMMENT '分区(yyyy-mm-dd)-inputtime')
 STORED AS PARQUET
 LOCATION
   '/dw/hive/jms_ods.db/external/yl_oms_order_delivery_record';